package com.cy.demo523.untitled2.src.com.cy.dao523;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserDao {
    Connection connection =  SqlCannection.getCon() ;
    public UserDao() throws SQLException, ClassNotFoundException {

    }
    public int addUser(String username, String password )throws SQLException , ClassNotFoundException {

        Connection connection =SqlCannection.getCon();
        String sql ="insert into users (username,password) values (?,?)";
        PreparedStatement preparedStatement  =connection .prepareStatement(sql) ;
        preparedStatement .setString(1,username) ;
        preparedStatement .setString(2,password) ;
        return preparedStatement .executeUpdate() ;
    }
    public Users login(String username, String password) throws SQLException, ClassNotFoundException {
        Users users = null;
        int i = 1;
        Connection connection = SqlCannection.getCon();
        String sql = "select * from users where username=? and password=?";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1, username);
        preparedStatement.setString(2, password);
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            users = new Users();
            users.setId(resultSet.getInt("id"));
            users.setUsername(resultSet.getString("username"));
            users.setPassword(resultSet.getString("password"));

        }
        return users;
    }
    public int deleteUsers(int id) throws SQLException, ClassNotFoundException {
        String sql = "delete from users where id =?";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setInt(1, id) ;
        return preparedStatement.executeUpdate();
    }
    public int updateUsers(int id, String Username) throws SQLException, ClassNotFoundException {
        String sql = "update  users SET username =? where id=? ";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement .setString(1,Username ) ;
        preparedStatement .setInt(2,id );
        return preparedStatement.executeUpdate() ;
    }
}
